/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost
 Source Database       : apiDatabase

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : utf-8

 Date: 01/22/2018 11:20:45 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `tab_api`
-- ----------------------------
DROP TABLE IF EXISTS `tab_api`;
CREATE TABLE `tab_api` (
  `api_id` varchar(32) NOT NULL,
  `api_name` varchar(255) DEFAULT NULL,
  `api_params` text,
  `api_desc` varchar(500) DEFAULT NULL,
  `group_id` varchar(32) DEFAULT NULL,
  `api_method` varchar(100) DEFAULT NULL,
  `api_time` datetime DEFAULT NULL,
  `system_id` varchar(32) DEFAULT NULL,
  `api_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`api_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tab_api`
-- ----------------------------
BEGIN;
INSERT INTO `tab_api` VALUES ('ByEIxGaNiOvSjEfd8leJ2MgXcaAleUwe', '基础设置列表', '[]', '基础设置列表', 'pFRdc35Xy0WnsGMGyAssF9AgU35MZ5CL', 'loadAllBacice.action', '2018-01-22 10:40:28', '5eJUSF7bNdm6TZJJTpLFtZOA4l22k5Ht', 'http://192.168.1.251:8089/manager/'), ('GjbjslB8TlkZzBLYoVkcnCn4ZCt1JfFe', '登陆', '[{\"id\":\"968fe02d08704\",\"param_key\":\"account\",\"param_dec\":\"\",\"param_null\":\"是\",\"param_value\":\"\",\"param_desc\":\"手机号码\"},{\"id\":\"d71d8ef9581e6\",\"param_key\":\"password\",\"param_dec\":\"\",\"param_null\":\"是\",\"param_value\":\"\",\"param_desc\":\"密码\"}]', '登陆获取session', '5JxcUwGgcpMkxtKzRxCB4PBYVUdOK6mE', 'login.action', '2018-01-22 10:47:23', '5eJUSF7bNdm6TZJJTpLFtZOA4l22k5Ht', 'http://192.168.1.251:8089/manager/');
COMMIT;

-- ----------------------------
--  Table structure for `tab_group`
-- ----------------------------
DROP TABLE IF EXISTS `tab_group`;
CREATE TABLE `tab_group` (
  `group_id` varchar(32) NOT NULL,
  `group_name` varchar(50) DEFAULT NULL,
  `system_id` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tab_group`
-- ----------------------------
BEGIN;
INSERT INTO `tab_group` VALUES ('5JxcUwGgcpMkxtKzRxCB4PBYVUdOK6mE', '登陆', '5eJUSF7bNdm6TZJJTpLFtZOA4l22k5Ht'), ('aZ7oMPK5Gh4aR6TqL0lWnrrNwDkIEF0C', '个人中心', 'zXEPDvFR8wcg7daBL3I8bdIkYMtQHH7M'), ('FP5I1PZ0ArTGEdDBZUAlAobBW8L4BgQ7', 'ASDAS', 'zXEPDvFR8wcg7daBL3I8bdIkYMtQHH7M'), ('l1nTwrODi6FzffMAWkexxU9gdP0QXeaq', '个人中心', 'kzk4kLJcdzauX0A5aTT36DbjqGMcz6qy'), ('LufWWfyAnUXRcrTjsOhoAMnoZpw54Rae', '新闻列表', 'kzk4kLJcdzauX0A5aTT36DbjqGMcz6qy'), ('mB2xnQ91XxiMLdVF7ydSx8FdygxTArgi', '视频列表', 'kzk4kLJcdzauX0A5aTT36DbjqGMcz6qy'), ('pFRdc35Xy0WnsGMGyAssF9AgU35MZ5CL', '系统管理', '5eJUSF7bNdm6TZJJTpLFtZOA4l22k5Ht'), ('zlYQU060tupNo2JIrJoEY4VjQXCx5TtB', '默认分类', 'kzk4kLJcdzauX0A5aTT36DbjqGMcz6qy');
COMMIT;

-- ----------------------------
--  Table structure for `tab_system`
-- ----------------------------
DROP TABLE IF EXISTS `tab_system`;
CREATE TABLE `tab_system` (
  `system_id` varchar(32) NOT NULL,
  `system_name` varchar(20) DEFAULT NULL,
  `system_version` varchar(255) DEFAULT NULL,
  `system_desc` varchar(1000) DEFAULT NULL,
  `system_time` datetime DEFAULT NULL,
  PRIMARY KEY (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tab_system`
-- ----------------------------
BEGIN;
INSERT INTO `tab_system` VALUES ('5eJUSF7bNdm6TZJJTpLFtZOA4l22k5Ht', '海贝后台管理中心', '1.2.3', '新版海贝后台管理中心', '2018-01-22 10:36:26'), ('O8kh15LGtNqjVv6IKIZeCk28f3IEjuBQ', '测试项目', '1.0', '测试项目介绍', '2018-01-22 11:18:55');
COMMIT;

-- ----------------------------
--  Table structure for `tab_users`
-- ----------------------------
DROP TABLE IF EXISTS `tab_users`;
CREATE TABLE `tab_users` (
  `user_id` varchar(32) NOT NULL,
  `user_name` varchar(32) DEFAULT NULL,
  `user_password` varchar(32) DEFAULT NULL,
  `user_mobile` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
